Formatting And Editting in MS Excel
Formatting Toolbar in MS Excel
The formatting toolbar found in most applications with text editing features is used to change the format of selected text. It contains a series of icons that act as shortcuts to frequently used formatting commands. The series are as follows:-| Font - Provides a list of all the available fonts (based on your current printer selection). |
| Font Size - Lets you adjust the character size (based on your current font selection). |
| Bold - Toggles bold on the current selection. |
| Italic - Toggles italics on the current selection. |
| Underline - Toggles underline on the current selection. |
| Align Left - Aligns data to the left edge of the cell. |
| Center - Aligns data in the middle of the cell. |
| Align Right - Aligns data to the right edge of the cell. |
| Wrap Text - Text inside the cell wraps to fit the column width. Text wrapping adjusts automatically when you change the column width. |
| Merge and Center - Combines 2 or more adjacent cells to create a single cell. |
| Currency Style - Applies the currency format "£##". |
| Percent Style - Displays the number as a percentage by applying the format "0%". |
| Comma Style - Adds a comma and two decimal places to the number by applying the format "#,##0.00". |
| Increase Decimal - Adds one decimal place from the number. |
| Decrease Decimal - Removes one decimal place from the number. |
| Decrease Indent - Decreases the indent by 1 or removes the indent completely. |
| Increase Indent - Increases the indent by 1. |
| Borders - Applies a border to the current selection. |
| Fill Color - Applies a color to the background of the current selection. This is actually a tear off toolbar. |
| Font Color - Changes the color of the font of the current selection. This is actually a tear off toolbar. |
The shortcut key to select the current column, press _______________________ . | |||
| Right Option : A | |||
| View Explanation | |||
How can you remove borders that have been applied to the cells ? | |||
| Right Option : C | |||
| View Explanation | |||
The cell accepts your typing as its contents, if you press _________________ . | |||
| Right Option : A | |||
| View Explanation | |||
Students / Parents Reviews [20]
Abhyas institute is one of the best coaching institute in the vicinity of Ambala cantt.The institute provides good and quality education to the students.The teachers are well experienced and are very helpful in solving the problems. The major advantages of the institute is extra classes for weak...
Shreya Shrivastava
8thUsually we see institutes offering objective based learning which usually causes a lag behind in subjective examinations which is the pattern followed by schools. I think it is really a work of planning to make us students grab the advantages of modes of examination, Objective Subjective and Onli...
Anika Saxena
8thAbhyas is good institution and a innovative institute also. It is a good platform of beginners.Due to Abhyas,he has got knoweledge about reasoning and confidence.My son has improved his vocabulary because of Abhyas.Teacher have very friendly atmosphere also.
Manish Kumar
10thI have spent a wonderful time in Abhyas academy. It has made my reasoning more apt, English more stronger and Maths an interesting subject for me. It has given me a habbit of self studying
Yatharthi Sharma
10thBeing a parent, I saw my daughter improvement in her studies by seeing a good result in all day to day compititive exam TMO, NSO, IEO etc and as well as studies. I have got a fruitful result from my daughter.
Prisha Gupta
8thWe started with lot of hope that Abhyas will help in better understnding of complex topics of highers classes. we are not disappointed with the progress our child has made after attending Abhyas. Though need to mention that we expected a lot more. On a scale of 1-10, we would give may be 7.
Manya
8thThe experience was nice. I studied here for three years and saw a tremendous change in myself. I started liking subjects like English and SST which earlier I ran from. Extra knowledge gave me confidence to overcome competitive exams. One of the best institutes for secondary education.
Aman Kumar Shrivastava
10thThird consective year,my ward is in Abhyas with nice experience of admin and transport support.Educational standard of the institute recumbent at satisfactory level. One thing would live to bring in notice that last year study books was distributed after half of the session was over,though study ...
Ayan Ghosh
8thIt was a good experience with Abhyas Academy. I even faced problems in starting but slowly and steadily overcomed. Especially reasoning classes helped me a lot.
Cheshta
10thAbhyas institute is one of the best coaching institute in the vicinity of Ambala Cantt area. The teachers of the institute are well experienced and very helpful in solving the problems of the students.The good thing of the institute is that it is providing extra classes for the students who are w...
Aman Kumar Shrivastava
10thAbhyas is an institute of high repute. Yogansh has taken admission last year. It creates abilities in child to prepare for competitive exams. Students are motivated by living prizes on basis of performance in Abhyas exams. He is satisfied with institute.
Yogansh Nyasi
7thA marvelous experience with Abhyas. I am glad to share that my ward has achieved more than enough at the Ambala ABHYAS centre. Years have passed on and more and more he has gained. May the centre flourish and develop day by day by the grace of God.
Archit Segal
7thAbhyas is a complete education Institute. Here extreme care is taken by teacher with the help of regular exam. Extra classes also conducted by the institute, if the student is weak.
Om Umang
10thMy experience with Abhyas Academy has been very good. When I was not in Abhyas whenever teacher ask questions I could not speak it confidently but when I came in Abhyas, my speaking skills developed and now I am the first one to give the answer of teachers question.
Upmanyu Sharma
7thWhen I have not joined Abhyas Academy, my skills of solving maths problems were not clear. But, after joining it, my skills have been developed and my concepts of science and SST are very well. I also came to know about other subjects such as vedic maths and reasoning.
Sharandeep Singh
7thAbhyas academy is great place to learn. I have learnt a lot here they have finished my fear of not answering.It has created a habit of self studying in me.The teachers here are very supportive and helpful. Earlier my maths and science was good but now it has been much better than before.
Barkha Arora
10thMy experience with Abhyas academy is very good. I did not think that my every subject coming here will be so strong. The main thing is that the online tests had made me learn here more things.
Hiya Gupta
8thAbout Abhyas metholodology the teachers are very nice and hardworking toward students.The Centre Head Mrs Anu Sethi is also a brilliant teacher.Abhyas has taught me how to overcome problems and has always taken my doubts and suppoeted me.
Shreya Shrivastava
8thIn terms of methodology I want to say that institute provides expert guidence and results oriented monitering supplements by requsite study material along with regular tests which help the students to improve their education skills.The techniques of providing education helps the students to asses...
Aman Kumar Shrivastava
10thAbhyas Methodology is very good. It is based on according to student and each child manages accordingly to its properly. Methodology has improved the abilities of students to shine them in future.
